ALTER TABLE products
ADD COLUMN wholesale_price DECIMAL(15,2) NOT NULL DEFAULT 0 AFTER purchase_price,



ALTER TABLE products
ADD COLUMN retail_profit_percentage DECIMAL(5,2) NOT NULL DEFAULT 0.00,
ADD COLUMN wholesale_profit_percentage DECIMAL(5,2) NOT NULL DEFAULT 0.00,
ADD COLUMN photo VARCHAR(255) NULL;